Skip to main content

Create DML Inner Join in dataset.

DML Inner-Join tutorial: From DML Inner join you will learn to create DML dataset which contains two tables having join from two or move rows. The inner join selects all the available rows of the tables.

Follow steps to create DML Inner-Join dataset in OPNBI:-

  1. Go to Dataset section, Click on Create DML from bottom menu bar. As shown in figure below:

Docusaurus Slash Introduction

  1. The Create Data Module dialog box looks as shown in figure below:

Docusaurus Slash Introduction

  1. Enter Following detail in DML Module dialog box:

    Name: DML Inner Join Source: ClassicModels Expend tables from left side table view, As shown in figure below:

Docusaurus Slash Introduction

  1. Drag and Drop the OFFICES table from the Table list to Right side diagram box, then select all the columns of OFFICES table, click on submit button. Docusaurus Slash Introduction

  2. click on submit button. Docusaurus Slash Introduction

  3. After submitting, the diagram box will look like the figure below:

Docusaurus Slash Introduction

  1. Drag and drop the CUSTOMERS from the left table menu to right diagram box.

  2. Select all the column from CUSTOMERS table, and click submit button.

  3. After adding OFFICES and CUSTOMERS from the table list, Drag the COUNTRY column from Offices to Customers, as shown in figure below:

Docusaurus Slash Introduction

  1. Click on the thread between two tables, to add DML configuration.

Docusaurus Slash Introduction

  1. The DML configuration control box will open, Select the Inner Join radio button and Click on Submit button, as shown in figure below:

Docusaurus Slash Introduction

Note: Left Node should have OFFICES and Right Node should have CUSTOMERS.

  1. The Connection between two tables will looks as shown in figure below:

Docusaurus Slash Introduction

Note: Click on Submit to save the dataset.

Docusaurus Slash Introduction

  1. Create Dashboard from the Visualization section. Example name: DML Inner Join.

  2. After loading the Dashboard, Find Analysis Icon from the left vertical menu bar, click on the icon to load analysis widget in dashboard.

Docusaurus Slash Introduction

  1. The Analysis widget will get load in dashboard automatically after clicking on the analysis icon. Select the Dataset(dml): DML Inner Join.

Docusaurus Slash Introduction

  1. Click on Field icon from Analysis widget, then the Analysis Selection dialog box will open, as shown in figure below:

Docusaurus Slash Introduction

  1. The two table will get load the left side box of DML view, Now expends the OFFICES table.
  2. Drag and drop COUNTRY column from OFFICES to Rows, the Value Column will take the count column automatically (Just Delete it), Drag and drop Territory column from OFFICE and Put it in Column box, Drag and drop the Credit Limit column from Customers to Values box (Select sum in Type).

Docusaurus Slash Introduction

  1. Click on Preview and Save and Exit. and save the dashboard.

  2. The output of the widget will look like available figure below:

Docusaurus Slash Introduction

More features of OPNBI as follows:​

DML Inner Join​

DML Left Join​

DML Right Join​

DML Language Alias​

DML using Parameter​

DML with multiple join condition​